package cn.ecut.dao;


import cn.ecut.model.Examine;
import cn.ecut.model.Relative;
import cn.ecut.model.ScholarshipApply;
import cn.ecut.model.Student;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface ScholarshipApplyDao {
    String selectArea(String id);
    Integer insertScholarshipApply(ScholarshipApply scholarshipApply);
    Integer insertRelative(List<Relative> relativeList);
    void updataApplyNum(Integer sid);
    Integer deleteRelative();
    Integer deleteScholarshipApply();
    Integer selectScholarshipResidue(Integer sid);
    List<Integer> selectIsApply(String number);
    List<Integer> selectIsHave(String number);
    Integer selectApplyCount(String number);
    List<Examine> selectExamineByPage(@Param("offset")int offset, @Param("num")int num);
    Integer selectAllApplyCount();
    List<Examine> advanceSelect(@Param("s") String s,@Param("offset")int offset,@Param("num")int num);
    Integer advanceSelectCount(String s);
    int selectScholarshipApplyStateByid(Integer id);
    Integer deleteScholarshipApplyByid(Integer id);
    Student selectStudentAndRelative(@Param("number") String number ,@Param("sid") Integer sid);
    ScholarshipApply selectScholarship(Integer id);
    Integer selectSidByid(Integer id);
    Integer pass(Integer id);
    Integer out(Integer id);
}
